UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iF09JQEFIBcM0Zi7kZdPSpCIG/KenANjhSaY+sG8kqY='
WHERE
key_id = '4b187a2347770255bbb99fd4851897d16ed4f54f8543869e98ad92375422cece'
AND (
token = 'iF09JQEFIBcM0Zi7kZdPSpCIG/KenANjhSaY+sG8kqY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)