UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gqhg807J/8mcSRIS81Gtk+7cbm0Ml0x7nw2v+eViZY0='
WHERE
key_id = 'a7127b9162df3d6de265acb0bbf1d4e98f306322e72b3f5b72171db690243d07'
AND (
token = 'Gqhg807J/8mcSRIS81Gtk+7cbm0Ml0x7nw2v+eViZY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)