UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wphC6MYNpiK5rvnvf5I6vy9dHZTuC5UCCl8BrOAFyC4='
WHERE
key_id = '4ec988915a5673c479612bc9d849b58c0d28459e865cd9cb87d3f44f209ca2a1'
AND (
token = 'wphC6MYNpiK5rvnvf5I6vy9dHZTuC5UCCl8BrOAFyC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)