UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TGdMZ9sCZAxGU80tTkuq1++iLR4L8gGpRBbMbhYPt0I=' 
WHERE 
  key_id = 'e0dc51ddd97749b3f6dd63e9ff4a5ae1f2c255e1c6d0212df3a653480207e97d' 
  AND (
    token = 'TGdMZ9sCZAxGU80tTkuq1++iLR4L8gGpRBbMbhYPt0I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031