UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gY3SeWcTpct0ZPLfDmHm2/6XdcQDLeB7VB7RQ02RHcU=' 
WHERE 
  key_id = '8314a6b571507cf3033486da212f10923b4fc3fa6b6a0fbfa78c7578919a45a0' 
  AND (
    token = 'gY3SeWcTpct0ZPLfDmHm2/6XdcQDLeB7VB7RQ02RHcU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026