UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AKekHXRFivR7CSUS0yw8R+ulmDeLccQIw+a8J0YCdwU=' 
WHERE 
  key_id = 'f5ad84674718a0d4f5d2ea0f6979420a95f89712ba5a07ae412823f0b61e6e89' 
  AND (
    token = 'AKekHXRFivR7CSUS0yw8R+ulmDeLccQIw+a8J0YCdwU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042