UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NJMAll9C1GuRMnw99U0NvNN+ww2mwLUsdsfItdeA0tU=' 
WHERE 
  key_id = '226efa28aea8a839138ba6f94f714b5bede29335adaf7c7f03dbf8a5e8d49b3a' 
  AND (
    token = 'NJMAll9C1GuRMnw99U0NvNN+ww2mwLUsdsfItdeA0tU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026