UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZIGSHu6fnusQloYOxC06wEX3hB5SPtb0GxUWmpBUOes='
WHERE
key_id = '5106d2ca17247c31c38d4c3caca9fff2f24e8e8ec1b2561462da2de3ddaa837b'
AND (
token = 'ZIGSHu6fnusQloYOxC06wEX3hB5SPtb0GxUWmpBUOes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)