UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZajJ1fBpPMLjO1evDNvPp4FNA8eiGbTH3GYh4B8VB1Y='
WHERE
key_id = '78139ba8570cdd8785f4a16021adb139db738a87d4b43d470a3663ac448231f1'
AND (
token = 'ZajJ1fBpPMLjO1evDNvPp4FNA8eiGbTH3GYh4B8VB1Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)