UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GheuP5y3B96F/ME2fLWBd8gK6ss7vKJALHk1mE6hSYE=' 
WHERE 
  key_id = '4ab230f7712b5b6d49b69c543e1aa8c783f7a66ed9d2b6d4c11d1863d187965d' 
  AND (
    token = 'GheuP5y3B96F/ME2fLWBd8gK6ss7vKJALHk1mE6hSYE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028