UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'odUHZ34pysgKq4AZNt3r7eUvOSSK+sbUjOul4fBoDyc='
WHERE
key_id = 'f4c80db8a79cf6d9ff7a4c9ba647dab54c0774df0df75d68ba550d5f4fe7a532'
AND (
token = 'odUHZ34pysgKq4AZNt3r7eUvOSSK+sbUjOul4fBoDyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)