UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K07U4xlVYGiOkWdL8aqcaC2wRLjocs/3auSxeA1GAmc='
WHERE
key_id = 'c7cc2d08c02dd628387a85699f22b2b80c15ea03d4725191291f2ba721525478'
AND (
token = 'K07U4xlVYGiOkWdL8aqcaC2wRLjocs/3auSxeA1GAmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)