UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hL6Y664H5hAosx32ftVtO6tFv2EDAndqCCQX85zPdqY=' 
WHERE 
  key_id = '11079ba957bb137cf8609b7e32a68269ef0de7c117f832986f7dd8b2b3e23aed' 
  AND (
    token = 'hL6Y664H5hAosx32ftVtO6tFv2EDAndqCCQX85zPdqY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027