UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hnDTrfXDL5hHurm5BoBZXnFIfCUPUOtQzAamgIAx99s='
WHERE
key_id = '5c163f02a2d5d2a672d8972b393273f7675cf3205b2f967b5087780c917d706d'
AND (
token = 'hnDTrfXDL5hHurm5BoBZXnFIfCUPUOtQzAamgIAx99s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)