UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+j5y9+JLbnTLr7NTEuR8uMTRdkTZ22McOTFHOhgaF8c=' 
WHERE 
  key_id = '3476ea6c0ffdb6b9b464876493f3a4487c5a9020f7eaf1b127a3fe9e05e1a7cf' 
  AND (
    token = '+j5y9+JLbnTLr7NTEuR8uMTRdkTZ22McOTFHOhgaF8c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027