UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BZTfXPbd5qY3pbNMGss6e7LohGNAGVEOy1lyZfJXMjA='
WHERE
key_id = '4d56e731d4375e64bd6183a0f572cd977f2694222fc75d21387a61a2c39a84d4'
AND (
token = 'BZTfXPbd5qY3pbNMGss6e7LohGNAGVEOy1lyZfJXMjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)