UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NkW7aFBsb6P72+I/4Na5e1ycEGWkd1nlVdA+6TpMVj4=' 
WHERE 
  key_id = '8f97eab95c15498f477da56d066fd9b67814f04438bd48bdbe4f3ee4e4c99aaf' 
  AND (
    token = 'NkW7aFBsb6P72+I/4Na5e1ycEGWkd1nlVdA+6TpMVj4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042