UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ntdLto9Mt76vZy5BY40RHDpwvyJKB1lcMT2tuUE3Y5U=' 
WHERE 
  key_id = '880a3b8dc432bd3c335d2c2606e217867b8a27c3b8d215d7fd52e6032ea631c0' 
  AND (
    token = 'ntdLto9Mt76vZy5BY40RHDpwvyJKB1lcMT2tuUE3Y5U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030