UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8Gj1J2KwYDb6y7/tOsko9HAZuOsf3KzZjplVUlClBmI=' 
WHERE 
  key_id = 'c744f92740ab86357e92ba7503758b4ddbe063cff312c2e70135b08e104df230' 
  AND (
    token = '8Gj1J2KwYDb6y7/tOsko9HAZuOsf3KzZjplVUlClBmI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022