UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qPqXmEm0bd4l6SRQ1Q+rkEv/Gvjk13hihyJj5V8ZeA0=' 
WHERE 
  key_id = '49bf4fced9be28cac335711333431fb1709373a6fac971448751d81c7b5b039b' 
  AND (
    token = 'qPqXmEm0bd4l6SRQ1Q+rkEv/Gvjk13hihyJj5V8ZeA0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036