UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5JMFlh2Q11oYH/tdb8dnsCwMs8NbtUml5l8tWITQ5qo=' 
WHERE 
  key_id = '38fcf2e2e573f6ef8c21418bd12d3b52e6fba9af03a733618f6e93988106994e' 
  AND (
    token = '5JMFlh2Q11oYH/tdb8dnsCwMs8NbtUml5l8tWITQ5qo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029