UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zLn3M0FVJJ087yUc9A5sVBH1MwfgOvUJfURbEMHmhMA='
WHERE
key_id = '7986a98ec41c1a88809079018ae126e6fb050a06f213e09a51a53b3c8c541516'
AND (
token = 'zLn3M0FVJJ087yUc9A5sVBH1MwfgOvUJfURbEMHmhMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)