UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Nr7eQrmsXsbr3p7Y8T1sPh5DcDfGLYv6lv44RqQReGQ=' 
WHERE 
  key_id = '6b6e88de4eafdcfcbe649aa6070b10a3690b8fcb53e0e2bf26f703c8fe23fc7b' 
  AND (
    token = 'Nr7eQrmsXsbr3p7Y8T1sPh5DcDfGLYv6lv44RqQReGQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027