UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XU895BsNS4Yhxe0Qr/8W0NytYiMO7S9Tm4ulagWmSyo=' 
WHERE 
  key_id = '66050f2014118eef7b6ccbdb64d1ca048e71288dd9dac476f3f9d0d0fe736e5b' 
  AND (
    token = 'XU895BsNS4Yhxe0Qr/8W0NytYiMO7S9Tm4ulagWmSyo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042