UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sYtw1qOK5HTcOBVPj6haxDR8+EfG/K9b7Fw/VmrES94='
WHERE
key_id = '2723d3e02502d9d8b54604fc8c2ce010f0230de0bd0ecf7b3d30f10f79b0e204'
AND (
token = 'sYtw1qOK5HTcOBVPj6haxDR8+EfG/K9b7Fw/VmrES94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)