UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iN1sGxPRO+XZ3dhoIgty7yJ8Hh4IZAuNAfqD4QrzTJA='
WHERE
key_id = '2171a36f41a99a21754c8814e3c7789a52c0de7a76122ad50e4a715dd82988c5'
AND (
token = 'iN1sGxPRO+XZ3dhoIgty7yJ8Hh4IZAuNAfqD4QrzTJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)