UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EJbL3dwgLOGlMDdHTPGN14ZJ3+/ruUq9AJBpkZMg/4U='
WHERE
key_id = 'b475b40737791874a29879939ce224729ae25592ba0b2a77ba4555041db9cfde'
AND (
token = 'EJbL3dwgLOGlMDdHTPGN14ZJ3+/ruUq9AJBpkZMg/4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)