UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HzVOfp+fjPp7pwHdl+Y83xENpGVFoP4PCMHJ3Nyk1fE='
WHERE
key_id = '4978f1d7ff55a6a5120b095f7d86e61588fce088f67be8b0f1c9e0b9adfcf9ee'
AND (
token = 'HzVOfp+fjPp7pwHdl+Y83xENpGVFoP4PCMHJ3Nyk1fE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)